Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2495

R_2495

PhFinancialSource

PhTradeDoc

FinancialSourceID

 

 

R_2496

R_2496

PhSt

PhTimeRelay

StID

 

 

R_2497

R_2497

PhTradeDoc

PhTradeDocDecree

TradeDocID

 

 

R_2498

R_2498

PhSt

PhTradeDocAccountDef

StID

 

 

R_2499

R_2499

PhStDocOrderType

PhStDocOrderTypeText

StDocOrderTypeID

 

 

R_2500

R_2500

PhStDocOrderType

PhStDoc

StDocOrderTypeID

 

 

R_2501

R_2501

REVINFO

PhStOrgUnitHist

REV

 

 

R_2502

R_2502

REVINFO

PhStHist

REV

 

 

R_2505

R_2505

PhLStDocStItemBundleType

PhLStDocStItemBundleTypeText

LStDocStItemBundleTypeID

 

 

R_2506

R_2506

PhStDoc

PhLStDocStItemBundle

StDocID

 

 

R_2507

R_2507

PhStItemBundle

PhLStDocStItemBundle

StItemBundleID

 

 

R_2508

R_2508

PhLStDocStItemBundleType

PhLStDocStItemBundle

LStDocStItemBundleTypeID

 

 

R_8660

R_8660

PhTenderOfferItem

PhTenderOfferItemStats

TenderOfferItemID

 

 

R_8802

R_8802

PhStOrderItem

PhDeliveryItemPrep

StOrderItemID

 

 

R_8803

R_8803

PhLotInSt

PhDeliveryItemPrep

LotInStID

 

 

R_8899

R_8899

PhTimePeriod

PhTimePeriodText

TimePeriodID

 

 

R_8900

R_8900

PhTimePeriod

PhTenderListItem

ValidityPeriodUnitID

 

 

R_8931

R_8931

PhCompany

PhStDoc

CompanyID

 

 

R_9060

R_9060

PhPack

PhLPackUnit

PackID

 

 

R_9061

R_9061

PhUnit

PhLPackUnit

UnitID

 

 

R_9073

R_9073

CostAccount

PhStDoc

OrderingCostAccountID

 

 

R_9088

R_9088

PhStItemGroup

PhLStItemGroupUserGroup

StItemGroupID

 

 

R_9089

R_9089

UserGroup

PhLStItemGroupUserGroup

UserGroupID

 

 

R_9096

R_9096

DrugAccessCategory

PhDrug

DrugAccessCategoryID

 

 

R_9220

R_9220

PhStOrder

PhStOrder

RelatedStOrderID

 

 

R_9221

R_9221

PhTradeDocItem

PhOrderRealization

TradeDocItemID

 

 

R_9222

R_9222

PhStDoc

PhLOrderDocument

StDocID

 

 

R_9291

R_9291

PhStOrder

PhLUserAssignStOrder

StOrderID

 

 

R_9292

R_9292

PhUserAssign

PhLUserAssignStOrder

UserAssignID

 

 

R_9311

R_9311

PhTenderOfferItem

PhOrderToDelivererItem

TenderOfferItemID

 

 

R_9312

R_9312

PhOrderToDeliverer

PhLTenderOffOrderToDel

OrderToDelivererID

 

 

R_9313

R_9313

PhTenderOffer

PhLTenderOffOrderToDel

TenderOfferID

 

 

R_9350

R_9350

PhSt

PhLimit

StID

 

 

R_9351

R_9351

PhRealizationType

PhRealizationTypeText

RealizationTypeID

 

 

R_9352

R_9352

PhRealizationMetaType

PhRealizationType

RealizationMetaTypeID

 

 

R_9353

R_9353

PhRealizationStatus

PhRealizationStatusText

RealizationStatusID

 

 

R_9354

R_9354

PhStOrder

PhLStOrderLimitRealization

StOrderID

 

 

R_9355

R_9355

PhLimit

PhLimitRealization

LimitID

 

 

R_9356

R_9356

PhRealizationType

PhLimitRealization

RealizationTypeID

 

 

R_9357

R_9357

PhRealizationStatus

PhLimitRealization

RealizationStatusID

 

 

R_9358

R_9358

PhLimitRealization

PhLStOrderLimitRealization

LimitRealizationID

 

 

R_9372

R_9372

PhStItemKind

PhStItemKind

ParentID

 

 

R_9373

R_9373

PhStItemKind

PhStItemKindText

StItemKindID

 

 

R_9374

R_9374

PhStItemKind

PhStItem

StItemKindID

 

 

R_9410

R_9410

PhSt

PhAccountingPeriod

StID

 

 

R_9411

R_9411

PhStDoc

PhStDocDecree

StDocID

 

 

R_9420

R_9420

PhSt

PhLTenderOfferSt

StID

 

 

R_9421

R_9421

PhTenderOffer

PhLTenderOfferSt

TenderOfferID

 

 

R_9428

R_9428

PhCpv

PhAuction

CpvID

 

 

R_9429

R_9429

PhAuction

PhAuctionPackage

AuctionID

 

 


1  2  3  4  5  6  7  8